Format consistency

Characteristic Name:	Format consistency
Definition:	Data formats are consistently used
Dimension:	Consistency
Granularity:	Element
Characteristic Type:	Declarative
Implementation Form:	Rule-based approach

Verification Metric:

The number of inconsistent data formats reported in an attribute per thousand records

Validation Metric:

To what extent required rules have been identified and implemented to maintain the declarative characteristic in concern.

BackgroundGuidelines

The original definitions given below formed the basis of the consolidated definition of the characteristic.

Definition:	Source:
A measure of the equivalence of information stored or used in various data stores, applications, and systems, and the processes for making data equivalent	D. McGilvray, “Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information”, Morgan Kaufmann Publishers, 2008. More from this source
The extent to which similar attributes or elements of an information object are consistently represented using the same structure, format, and precision.	STVILIA, B., GASSER, L., TWIDALE, M. B. & SMITH, L. C. 2007. A framework for information quality assessment. Journal of the American Society for Information Science and Technology, 58, 1720-1733. More from this source

The implementation guidelines are guidelines to follow in regard to the characteristic. The scenarios are examples of the implementation

Guidelines:	Scenario:
Maintain consistent formats for data values across different data bases and different tables in the same database.	(1) Telephone number : Country code/Area code/number (2) Address : House number, Street, Suburb, Sate, Country
Maintain structural similarity or compatibility of entities and attributes across systems (databases/data sets) and across time.	(1) Customer record has the same structure in all systems which it is being used.
Maintain consistent and compatible encoding /decoding standards across different applications.	(1) ASCII, UTF-8, XML